Oracle Bulk Collect Into Kullanımı

 

set serveroutput on;

declare

type t_ad is table of varchar2 (20);

type t_maas is table of numler;

v_ad t_ad;

v_maas t_maas;

begin

select ad, maas bulk collect into v_ad,v_maas

from personel;

for idx in 1..v_ad.count

loop  

dbms_output.put_line(idx||' - '||v_ad (idx) || ' : '||v_maas (idx));

end loop;

end;